﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ESRPDataSet" targetNamespace="http://tempuri.org/ESRPDataSet.xsd" xmlns:mstns="http://tempuri.org/ESRPDataSet.xsd" xmlns="http://tempuri.org/ESRPDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection ConnectionStringObject="Data Source=localhost;Initial Catalog=ESRP;User ID=Admin" IsAppSettingsProperty="false" Modifier="Assembly" Name="DatabaseContext (ERPStudio.Web)" ParameterPrefix="@" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="AdreseTableAdapter" GeneratorDataComponentClassName="AdreseTableAdapter" Name="Adrese" UserDataComponentName="AdreseTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.Adrese" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Adrese] WHERE (([IDAdresa] = @Original_IDAdresa) AND ((@IsNull_IDJudet = 1 AND [IDJudet] IS NULL) OR ([IDJudet] = @Original_IDJudet)) AND ((@IsNull_IDLocalitati = 1 AND [IDLocalitati] IS NULL) OR ([IDLocalitati] = @Original_IDLocalitati)) AND ((@IsNull_Strada = 1 AND [Strada] IS NULL) OR ([Strada] = @Original_Strada)) AND ((@IsNull_Numar = 1 AND [Numar] IS NULL) OR ([Numar] = @Original_Numar)) AND ((@IsNull_Bloc = 1 AND [Bloc] IS NULL) OR ([Bloc] = @Original_Bloc)) AND ((@IsNull_Scara = 1 AND [Scara] IS NULL) OR ([Scara] = @Original_Scara)) AND ((@IsNull_Apartament = 1 AND [Apartament] IS NULL) OR ([Apartament] = @Original_Apartament)) AND ((@IsNull_IDTara = 1 AND [IDTara] IS NULL) OR ([IDTara] = @Original_IDTara)) AND ((@IsNull_Observatii = 1 AND [Observatii] IS NULL) OR ([Observatii] = @Original_Observatii)) AND ((@IsNull_IDPartener = 1 AND [IDPartener] IS NULL) OR ([IDPartener] = @Original_IDPartener)) AND ((@IsNull_CodPostal = 1 AND [CodPostal] IS NULL) OR ([CodPostal] = @Original_CodPostal)) AND ((@IsNull_IDTipAdresa = 1 AND [IDTipAdresa] IS NULL) OR ([IDTipAdresa] = @Original_IDTipAdresa)) AND ((@IsNull_Telefon = 1 AND [Telefon] IS NULL) OR ([Telefon] = @Original_Telefon)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAdresa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAdresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDLocalitati" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitati" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitati" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitati" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Strada" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Strada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Strada" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Strada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Numar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Numar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Bloc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bloc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bloc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bloc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Scara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Scara" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Scara" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Scara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Apartament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Apartament" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Apartament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Apartament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Observatii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPartener" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPostal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTipAdresa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTipAdresa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipAdresa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipAdresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Adrese] ([IDJudet], [IDLocalitati], [Strada], [Numar], [Bloc], [Scara], [Apartament], [IDTara], [Observatii], [IDPartener], [CodPostal], [IDTipAdresa], [Telefon], [Fax]) VALUES (@IDJudet, @IDLocalitati, @Strada, @Numar, @Bloc, @Scara, @Apartament, @IDTara, @Observatii, @IDPartener, @CodPostal, @IDTipAdresa, @Telefon, @Fax);
SELECT IDAdresa, IDJudet, IDLocalitati, Strada, Numar, Bloc, Scara, Apartament, IDTara, Observatii, IDPartener, CodPostal, IDTipAdresa, Telefon, Fax FROM Adrese WHERE (IDAdresa = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocalitati" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitati" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Strada" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Strada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Numar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Numar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bloc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bloc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Scara" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Scara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Apartament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Apartament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDTipAdresa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipAdresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDAdresa, IDJudet, IDLocalitati, Strada, Numar, Bloc, Scara, Apartament, IDTara, Observatii, IDPartener, CodPostal, IDTipAdresa, Telefon, Fax FROM dbo.Adrese</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Adrese] SET [IDJudet] = @IDJudet, [IDLocalitati] = @IDLocalitati, [Strada] = @Strada, [Numar] = @Numar, [Bloc] = @Bloc, [Scara] = @Scara, [Apartament] = @Apartament, [IDTara] = @IDTara, [Observatii] = @Observatii, [IDPartener] = @IDPartener, [CodPostal] = @CodPostal, [IDTipAdresa] = @IDTipAdresa, [Telefon] = @Telefon, [Fax] = @Fax WHERE (([IDAdresa] = @Original_IDAdresa) AND ((@IsNull_IDJudet = 1 AND [IDJudet] IS NULL) OR ([IDJudet] = @Original_IDJudet)) AND ((@IsNull_IDLocalitati = 1 AND [IDLocalitati] IS NULL) OR ([IDLocalitati] = @Original_IDLocalitati)) AND ((@IsNull_Strada = 1 AND [Strada] IS NULL) OR ([Strada] = @Original_Strada)) AND ((@IsNull_Numar = 1 AND [Numar] IS NULL) OR ([Numar] = @Original_Numar)) AND ((@IsNull_Bloc = 1 AND [Bloc] IS NULL) OR ([Bloc] = @Original_Bloc)) AND ((@IsNull_Scara = 1 AND [Scara] IS NULL) OR ([Scara] = @Original_Scara)) AND ((@IsNull_Apartament = 1 AND [Apartament] IS NULL) OR ([Apartament] = @Original_Apartament)) AND ((@IsNull_IDTara = 1 AND [IDTara] IS NULL) OR ([IDTara] = @Original_IDTara)) AND ((@IsNull_Observatii = 1 AND [Observatii] IS NULL) OR ([Observatii] = @Original_Observatii)) AND ((@IsNull_IDPartener = 1 AND [IDPartener] IS NULL) OR ([IDPartener] = @Original_IDPartener)) AND ((@IsNull_CodPostal = 1 AND [CodPostal] IS NULL) OR ([CodPostal] = @Original_CodPostal)) AND ((@IsNull_IDTipAdresa = 1 AND [IDTipAdresa] IS NULL) OR ([IDTipAdresa] = @Original_IDTipAdresa)) AND ((@IsNull_Telefon = 1 AND [Telefon] IS NULL) OR ([Telefon] = @Original_Telefon)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)));
SELECT IDAdresa, IDJudet, IDLocalitati, Strada, Numar, Bloc, Scara, Apartament, IDTara, Observatii, IDPartener, CodPostal, IDTipAdresa, Telefon, Fax FROM Adrese WHERE (IDAdresa = @IDAdresa)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDLocalitati" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitati" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Strada" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Strada" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Numar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Numar" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Bloc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bloc" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Scara" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Scara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Apartament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Apartament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDTipAdresa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipAdresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDAdresa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDAdresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDLocalitati" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitati" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitati" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitati" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Strada" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Strada" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Strada" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Strada" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Numar" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Numar" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Numar" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Numar" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Bloc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Bloc" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Bloc" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Bloc" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Scara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Scara" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Scara" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Scara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Apartament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Apartament" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Apartament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Apartament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Observatii" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Observatii" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Observatii" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPartener" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPostal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTipAdresa" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTipAdresa" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipAdresa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipAdresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDAdresa" ColumnName="IDAdresa" DataSourceName="ESRP.dbo.Adrese" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDAdresa" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDAdresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDAdresa" DataSetColumn="IDAdresa" />
              <Mapping SourceColumn="IDJudet" DataSetColumn="IDJudet" />
              <Mapping SourceColumn="IDLocalitati" DataSetColumn="IDLocalitati" />
              <Mapping SourceColumn="Strada" DataSetColumn="Strada" />
              <Mapping SourceColumn="Numar" DataSetColumn="Numar" />
              <Mapping SourceColumn="Bloc" DataSetColumn="Bloc" />
              <Mapping SourceColumn="Scara" DataSetColumn="Scara" />
              <Mapping SourceColumn="Apartament" DataSetColumn="Apartament" />
              <Mapping SourceColumn="IDTara" DataSetColumn="IDTara" />
              <Mapping SourceColumn="Observatii" DataSetColumn="Observatii" />
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
              <Mapping SourceColumn="CodPostal" DataSetColumn="CodPostal" />
              <Mapping SourceColumn="IDTipAdresa" DataSetColumn="IDTipAdresa" />
              <Mapping SourceColumn="Telefon" DataSetColumn="Telefon" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.Adrese" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIDPartener" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillByIDPartener" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByIDPartener">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT Apartament, Bloc, CodPostal, Fax, IDAdresa, IDJudet, IDLocalitati, IDPartener, IDTara, IDTipAdresa, Numar, Observatii, Scara, Strada, Telefon FROM Adrese WHERE (IDPartener = @IdPartener)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="IdPartener" ColumnName="IDPartener" DataSourceName="ESRP.dbo.Adrese" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@IdPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="JudeteTableAdapter" GeneratorDataComponentClassName="JudeteTableAdapter" Name="Judete" UserDataComponentName="JudeteTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.Judete" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Judete] WHERE (([IDJudet] = @Original_IDJudet) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)) AND ((@IsNull_PrefixTelefonic = 1 AND [PrefixTelefonic] IS NULL) OR ([PrefixTelefonic] = @Original_PrefixTelefonic)) AND ((@IsNull_ResedintaJudet = 1 AND [ResedintaJudet] IS NULL) OR ([ResedintaJudet] = @Original_ResedintaJudet)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrefixTelefonic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResedintaJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ResedintaJudet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Judete] ([Nume], [Sigla], [PrefixTelefonic], [ResedintaJudet]) VALUES (@Nume, @Sigla, @PrefixTelefonic, @ResedintaJudet);
SELECT IDJudet, Nume, Sigla, PrefixTelefonic, ResedintaJudet FROM Judete WHERE (IDJudet = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ResedintaJudet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDJudet, Nume, Sigla, PrefixTelefonic, ResedintaJudet FROM dbo.Judete</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Judete] SET [Nume] = @Nume, [Sigla] = @Sigla, [PrefixTelefonic] = @PrefixTelefonic, [ResedintaJudet] = @ResedintaJudet WHERE (([IDJudet] = @Original_IDJudet) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Sigla = 1 AND [Sigla] IS NULL) OR ([Sigla] = @Original_Sigla)) AND ((@IsNull_PrefixTelefonic = 1 AND [PrefixTelefonic] IS NULL) OR ([PrefixTelefonic] = @Original_PrefixTelefonic)) AND ((@IsNull_ResedintaJudet = 1 AND [ResedintaJudet] IS NULL) OR ([ResedintaJudet] = @Original_ResedintaJudet)));
SELECT IDJudet, Nume, Sigla, PrefixTelefonic, ResedintaJudet FROM Judete WHERE (IDJudet = @IDJudet)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ResedintaJudet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sigla" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_Sigla" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="Sigla" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrefixTelefonic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ResedintaJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ResedintaJudet" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ResedintaJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDJudet" ColumnName="IDJudet" DataSourceName="ESRP.dbo.Judete" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDJudet" DataSetColumn="IDJudet" />
              <Mapping SourceColumn="Nume" DataSetColumn="Nume" />
              <Mapping SourceColumn="Sigla" DataSetColumn="Sigla" />
              <Mapping SourceColumn="PrefixTelefonic" DataSetColumn="PrefixTelefonic" />
              <Mapping SourceColumn="ResedintaJudet" DataSetColumn="ResedintaJudet" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LocalitatiTableAdapter" GeneratorDataComponentClassName="LocalitatiTableAdapter" Name="Localitati" UserDataComponentName="LocalitatiTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.Localitati" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Localitati] WHERE (([IDLocalitate] = @Original_IDLocalitate) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_CodPostal = 1 AND [CodPostal] IS NULL) OR ([CodPostal] = @Original_CodPostal)) AND ((@IsNull_IDJudet = 1 AND [IDJudet] IS NULL) OR ([IDJudet] = @Original_IDJudet)) AND ((@IsNull_PrefixTelefonic = 1 AND [PrefixTelefonic] IS NULL) OR ([PrefixTelefonic] = @Original_PrefixTelefonic)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPostal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrefixTelefonic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Localitati] ([Nume], [CodPostal], [IDJudet], [PrefixTelefonic]) VALUES (@Nume, @CodPostal, @IDJudet, @PrefixTelefonic);
SELECT IDLocalitate, Nume, CodPostal, IDJudet, PrefixTelefonic FROM Localitati WHERE (IDLocalitate = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDLocalitate, Nume, CodPostal, IDJudet, PrefixTelefonic FROM dbo.Localitati</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Localitati] SET [Nume] = @Nume, [CodPostal] = @CodPostal, [IDJudet] = @IDJudet, [PrefixTelefonic] = @PrefixTelefonic WHERE (([IDLocalitate] = @Original_IDLocalitate) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_CodPostal = 1 AND [CodPostal] IS NULL) OR ([CodPostal] = @Original_CodPostal)) AND ((@IsNull_IDJudet = 1 AND [IDJudet] IS NULL) OR ([IDJudet] = @Original_IDJudet)) AND ((@IsNull_PrefixTelefonic = 1 AND [PrefixTelefonic] IS NULL) OR ([PrefixTelefonic] = @Original_PrefixTelefonic)));
SELECT IDLocalitate, Nume, CodPostal, IDJudet, PrefixTelefonic FROM Localitati WHERE (IDLocalitate = @IDLocalitate)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDLocalitate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDLocalitate" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CodPostal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_CodPostal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="CodPostal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDJudet" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDJudet" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_PrefixTelefonic" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_PrefixTelefonic" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="PrefixTelefonic" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDLocalitate" ColumnName="IDLocalitate" DataSourceName="ESRP.dbo.Localitati" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDLocalitate" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDLocalitate" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDLocalitate" DataSetColumn="IDLocalitate" />
              <Mapping SourceColumn="Nume" DataSetColumn="Nume" />
              <Mapping SourceColumn="CodPostal" DataSetColumn="CodPostal" />
              <Mapping SourceColumn="IDJudet" DataSetColumn="IDJudet" />
              <Mapping SourceColumn="PrefixTelefonic" DataSetColumn="PrefixTelefonic" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TariTableAdapter" GeneratorDataComponentClassName="TariTableAdapter" Name="Tari" UserDataComponentName="TariTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.Tari" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Tari] WHERE (([IDTara] = @Original_IDTara) AND ((@IsNull_NUME = 1 AND [NUME] IS NULL) OR ([NUME] = @Original_NUME)) AND ((@IsNull_SIGLA = 1 AND [SIGLA] IS NULL) OR ([SIGLA] = @Original_SIGLA)) AND ((@IsNull_preftel = 1 AND [preftel] IS NULL) OR ([preftel] = @Original_preftel)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NUME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SIGLA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SIGLA" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_preftel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_preftel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Tari] ([NUME], [SIGLA], [preftel]) VALUES (@NUME, @SIGLA, @preftel);
SELECT IDTara, NUME, SIGLA, preftel FROM Tari WHERE (IDTara = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NUME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SIGLA" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@preftel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTara, NUME, SIGLA, preftel FROM dbo.Tari</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Tari] SET [NUME] = @NUME, [SIGLA] = @SIGLA, [preftel] = @preftel WHERE (([IDTara] = @Original_IDTara) AND ((@IsNull_NUME = 1 AND [NUME] IS NULL) OR ([NUME] = @Original_NUME)) AND ((@IsNull_SIGLA = 1 AND [SIGLA] IS NULL) OR ([SIGLA] = @Original_SIGLA)) AND ((@IsNull_preftel = 1 AND [preftel] IS NULL) OR ([preftel] = @Original_preftel)));
SELECT IDTara, NUME, SIGLA, preftel FROM Tari WHERE (IDTara = @IDTara)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@NUME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@SIGLA" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@preftel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDTara" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NUME" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_NUME" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="NUME" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SIGLA" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength" Direction="Input" ParameterName="@Original_SIGLA" Precision="0" ProviderType="Char" Scale="0" Size="0" SourceColumn="SIGLA" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_preftel" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_preftel" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="preftel" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTara" ColumnName="IDTara" DataSourceName="ESRP.dbo.Tari" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDTara" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDTara" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTara" DataSetColumn="IDTara" />
              <Mapping SourceColumn="NUME" DataSetColumn="NUME" />
              <Mapping SourceColumn="SIGLA" DataSetColumn="SIGLA" />
              <Mapping SourceColumn="preftel" DataSetColumn="preftel" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipAdresaTableAdapter" GeneratorDataComponentClassName="TipAdresaTableAdapter" Name="TipAdresa" UserDataComponentName="TipAdresaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.TipAdresa" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TipAdresa] WHERE (([IDTipAdresa] = @Original_IDTipAdresa) AND ([Denumire] = @Original_Denumire))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipAdresa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipAdresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TipAdresa] ([Denumire]) VALUES (@Denumire);
SELECT IDTipAdresa, Denumire FROM TipAdresa WHERE (IDTipAdresa = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTipAdresa, Denumire FROM dbo.TipAdresa</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TipAdresa] SET [Denumire] = @Denumire WHERE (([IDTipAdresa] = @Original_IDTipAdresa) AND ([Denumire] = @Original_Denumire));
SELECT IDTipAdresa, Denumire FROM TipAdresa WHERE (IDTipAdresa = @IDTipAdresa)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipAdresa" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipAdresa" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTipAdresa" ColumnName="IDTipAdresa" DataSourceName="ESRP.dbo.TipAdresa" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDTipAdresa" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDTipAdresa" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTipAdresa" DataSetColumn="IDTipAdresa" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ContactTableAdapter" GeneratorDataComponentClassName="ContactTableAdapter" Name="Contact" UserDataComponentName="ContactTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.Contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[Contact] WHERE (([IDContact] = @Original_IDContact) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Prenume = 1 AND [Prenume] IS NULL) OR ([Prenume] = @Original_Prenume)) AND ((@IsNull_IDTipContact = 1 AND [IDTipContact] IS NULL) OR ([IDTipContact] = @Original_IDTipContact)) AND ((@IsNull_CNP = 1 AND [CNP] IS NULL) OR ([CNP] = @Original_CNP)) AND ((@IsNull_StareCivila = 1 AND [StareCivila] IS NULL) OR ([StareCivila] = @Original_StareCivila)) AND ((@IsNull_Functie = 1 AND [Functie] IS NULL) OR ([Functie] = @Original_Functie)) AND ((@IsNull_Departament = 1 AND [Departament] IS NULL) OR ([Departament] = @Original_Departament)) AND ((@IsNull_TipAI = 1 AND [TipAI] IS NULL) OR ([TipAI] = @Original_TipAI)) AND ((@IsNull_SerieAI = 1 AND [SerieAI] IS NULL) OR ([SerieAI] = @Original_SerieAI)) AND ((@IsNull_NumarAI = 1 AND [NumarAI] IS NULL) OR ([NumarAI] = @Original_NumarAI)) AND ((@IsNull_IDPartener = 1 AND [IDPartener] IS NULL) OR ([IDPartener] = @Original_IDPartener)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prenume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTipContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CNP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StareCivila" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Functie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Departament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SerieAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumarAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPartener" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[Contact] ([Nume], [Prenume], [IDTipContact], [CNP], [StareCivila], [Functie], [Departament], [TipAI], [SerieAI], [NumarAI], [IDPartener]) VALUES (@Nume, @Prenume, @IDTipContact, @CNP, @StareCivila, @Functie, @Departament, @TipAI, @SerieAI, @NumarAI, @IDPartener);
SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM Contact WHERE (IDContact = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM dbo.Contact</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[Contact] SET [Nume] = @Nume, [Prenume] = @Prenume, [IDTipContact] = @IDTipContact, [CNP] = @CNP, [StareCivila] = @StareCivila, [Functie] = @Functie, [Departament] = @Departament, [TipAI] = @TipAI, [SerieAI] = @SerieAI, [NumarAI] = @NumarAI, [IDPartener] = @IDPartener WHERE (([IDContact] = @Original_IDContact) AND ((@IsNull_Nume = 1 AND [Nume] IS NULL) OR ([Nume] = @Original_Nume)) AND ((@IsNull_Prenume = 1 AND [Prenume] IS NULL) OR ([Prenume] = @Original_Prenume)) AND ((@IsNull_IDTipContact = 1 AND [IDTipContact] IS NULL) OR ([IDTipContact] = @Original_IDTipContact)) AND ((@IsNull_CNP = 1 AND [CNP] IS NULL) OR ([CNP] = @Original_CNP)) AND ((@IsNull_StareCivila = 1 AND [StareCivila] IS NULL) OR ([StareCivila] = @Original_StareCivila)) AND ((@IsNull_Functie = 1 AND [Functie] IS NULL) OR ([Functie] = @Original_Functie)) AND ((@IsNull_Departament = 1 AND [Departament] IS NULL) OR ([Departament] = @Original_Departament)) AND ((@IsNull_TipAI = 1 AND [TipAI] IS NULL) OR ([TipAI] = @Original_TipAI)) AND ((@IsNull_SerieAI = 1 AND [SerieAI] IS NULL) OR ([SerieAI] = @Original_SerieAI)) AND ((@IsNull_NumarAI = 1 AND [NumarAI] IS NULL) OR ([NumarAI] = @Original_NumarAI)) AND ((@IsNull_IDPartener = 1 AND [IDPartener] IS NULL) OR ([IDPartener] = @Original_IDPartener)));
SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM Contact WHERE (IDContact = @IDContact)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Nume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Nume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Nume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Prenume" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Prenume" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Prenume" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDTipContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_CNP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_CNP" Precision="13" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="CNP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StareCivila" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_StareCivila" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="StareCivila" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Functie" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Functie" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Functie" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Departament" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Departament" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Departament" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TipAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TipAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TipAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SerieAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SerieAI" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SerieAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NumarAI" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Decimal" Direction="Input" ParameterName="@Original_NumarAI" Precision="10" ProviderType="Decimal" Scale="0" Size="0" SourceColumn="NumarAI" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDPartener" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int64" Direction="Input" ParameterName="@Original_IDPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="0" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDContact" ColumnName="IDContact" DataSourceName="ESRP.dbo.Contact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDContact" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDContact" DataSetColumn="IDContact" />
              <Mapping SourceColumn="Nume" DataSetColumn="Nume" />
              <Mapping SourceColumn="Prenume" DataSetColumn="Prenume" />
              <Mapping SourceColumn="IDTipContact" DataSetColumn="IDTipContact" />
              <Mapping SourceColumn="CNP" DataSetColumn="CNP" />
              <Mapping SourceColumn="StareCivila" DataSetColumn="StareCivila" />
              <Mapping SourceColumn="Functie" DataSetColumn="Functie" />
              <Mapping SourceColumn="Departament" DataSetColumn="Departament" />
              <Mapping SourceColumn="TipAI" DataSetColumn="TipAI" />
              <Mapping SourceColumn="SerieAI" DataSetColumn="SerieAI" />
              <Mapping SourceColumn="NumarAI" DataSetColumn="NumarAI" />
              <Mapping SourceColumn="IDPartener" DataSetColumn="IDPartener" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.Contact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdPartener" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillByIdPartener" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByIdPartener">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDContact, Nume, Prenume, IDTipContact, CNP, StareCivila, Functie, Departament, TipAI, SerieAI, NumarAI, IDPartener FROM dbo.Contact WHERE IDPartener=@IdPartener</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="IdPartener" ColumnName="IDPartener" DataSourceName="ESRP.dbo.Contact" DataTypeServer="bigint" DbType="Int64" Direction="Input" ParameterName="@IdPartener" Precision="0" ProviderType="BigInt" Scale="0" Size="8" SourceColumn="IDPartener" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="InfoContactTableAdapter" GeneratorDataComponentClassName="InfoContactTableAdapter" Name="InfoContact" UserDataComponentName="InfoContactTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.InfoContact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[InfoContact] WHERE (([IDInfoContact] = @Original_IDInfoContact) AND ((@IsNull_Telefon = 1 AND [Telefon] IS NULL) OR ([Telefon] = @Original_Telefon)) AND ((@IsNull_Mobil = 1 AND [Mobil] IS NULL) OR ([Mobil] = @Original_Mobil)) AND ((@IsNull_TelefonPersonal = 1 AND [TelefonPersonal] IS NULL) OR ([TelefonPersonal] = @Original_TelefonPersonal)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_YMID = 1 AND [YMID] IS NULL) OR ([YMID] = @Original_YMID)) AND ((@IsNull_WebSite = 1 AND [WebSite] IS NULL) OR ([WebSite] = @Original_WebSite)) AND ((@IsNull_IDContact = 1 AND [IDContact] IS NULL) OR ([IDContact] = @Original_IDContact)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDInfoContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDInfoContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Mobil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Mobil" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Mobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mobil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonPersonal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonPersonal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonPersonal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonPersonal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_YMID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YMID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_YMID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="YMID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WebSite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WebSite" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_WebSite" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WebSite" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[InfoContact] ([Telefon], [Mobil], [TelefonPersonal], [Fax], [Email], [YMID], [WebSite], [IDContact]) VALUES (@Telefon, @Mobil, @TelefonPersonal, @Fax, @Email, @YMID, @WebSite, @IDContact);
SELECT IDInfoContact, Telefon, Mobil, TelefonPersonal, Fax, Email, YMID, WebSite, IDContact FROM InfoContact WHERE (IDInfoContact = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Mobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mobil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonPersonal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonPersonal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@YMID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="YMID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WebSite" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WebSite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDInfoContact, Telefon, Mobil, TelefonPersonal, Fax, Email, YMID, WebSite, IDContact FROM dbo.InfoContact</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[InfoContact] SET [Telefon] = @Telefon, [Mobil] = @Mobil, [TelefonPersonal] = @TelefonPersonal, [Fax] = @Fax, [Email] = @Email, [YMID] = @YMID, [WebSite] = @WebSite, [IDContact] = @IDContact WHERE (([IDInfoContact] = @Original_IDInfoContact) AND ((@IsNull_Telefon = 1 AND [Telefon] IS NULL) OR ([Telefon] = @Original_Telefon)) AND ((@IsNull_Mobil = 1 AND [Mobil] IS NULL) OR ([Mobil] = @Original_Mobil)) AND ((@IsNull_TelefonPersonal = 1 AND [TelefonPersonal] IS NULL) OR ([TelefonPersonal] = @Original_TelefonPersonal)) AND ((@IsNull_Fax = 1 AND [Fax] IS NULL) OR ([Fax] = @Original_Fax)) AND ((@IsNull_Email = 1 AND [Email] IS NULL) OR ([Email] = @Original_Email)) AND ((@IsNull_YMID = 1 AND [YMID] IS NULL) OR ([YMID] = @Original_YMID)) AND ((@IsNull_WebSite = 1 AND [WebSite] IS NULL) OR ([WebSite] = @Original_WebSite)) AND ((@IsNull_IDContact = 1 AND [IDContact] IS NULL) OR ([IDContact] = @Original_IDContact)));
SELECT IDInfoContact, Telefon, Mobil, TelefonPersonal, Fax, Email, YMID, WebSite, IDContact FROM InfoContact WHERE (IDInfoContact = @IDInfoContact)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Mobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mobil" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TelefonPersonal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonPersonal" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@YMID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="YMID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WebSite" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WebSite" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDInfoContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDInfoContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Telefon" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Telefon" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Telefon" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Mobil" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Mobil" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Mobil" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Mobil" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TelefonPersonal" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TelefonPersonal" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TelefonPersonal" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TelefonPersonal" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Fax" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Fax" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Fax" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Email" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Email" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Email" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_YMID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="YMID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_YMID" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="YMID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WebSite" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WebSite" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_WebSite" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WebSite" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_IDContact" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDInfoContact" ColumnName="IDInfoContact" DataSourceName="ESRP.dbo.InfoContact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDInfoContact" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDInfoContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDInfoContact" DataSetColumn="IDInfoContact" />
              <Mapping SourceColumn="Telefon" DataSetColumn="Telefon" />
              <Mapping SourceColumn="Mobil" DataSetColumn="Mobil" />
              <Mapping SourceColumn="TelefonPersonal" DataSetColumn="TelefonPersonal" />
              <Mapping SourceColumn="Fax" DataSetColumn="Fax" />
              <Mapping SourceColumn="Email" DataSetColumn="Email" />
              <Mapping SourceColumn="YMID" DataSetColumn="YMID" />
              <Mapping SourceColumn="WebSite" DataSetColumn="WebSite" />
              <Mapping SourceColumn="IDContact" DataSetColumn="IDContact" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.InfoContact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByIdContact" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="FillByIdContact" GetMethodModifier="Public" GetMethodName="GetDataBy" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="FillByIdContact">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT IDInfoContact, Telefon, Mobil, TelefonPersonal, Fax, Email, YMID, WebSite, IDContact FROM dbo.InfoContact WHERE IDContact=@IDContact</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="IDContact" ColumnName="IDContact" DataSourceName="ESRP.dbo.InfoContact" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@IDContact" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="IDContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TipContactTableAdapter" GeneratorDataComponentClassName="TipContactTableAdapter" Name="TipContact" UserDataComponentName="TipContactTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="DatabaseContext (ERPStudio.Web)" DbObjectName="ESRP.dbo.TipContact" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[TipContact] WHERE (([IDTipContact] = @Original_IDTipContact) AND ([Denumire] = @Original_Denumire))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[TipContact] ([Denumire]) VALUES (@Denumire);
SELECT IDTipContact, Denumire FROM TipContact WHERE (IDTipContact = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT IDTipContact, Denumire FROM dbo.TipContact</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[TipContact] SET [Denumire] = @Denumire WHERE (([IDTipContact] = @Original_IDTipContact) AND ([Denumire] = @Original_Denumire));
SELECT IDTipContact, Denumire FROM TipContact WHERE (IDTipContact = @IDTipContact)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int16" Direction="Input" ParameterName="@Original_IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="0" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Denumire" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Denumire" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="IDTipContact" ColumnName="IDTipContact" DataSourceName="ESRP.dbo.TipContact" DataTypeServer="smallint" DbType="Int16" Direction="Input" ParameterName="@IDTipContact" Precision="0" ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="IDTipContact" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IDTipContact" DataSetColumn="IDTipContact" />
              <Mapping SourceColumn="Denumire" DataSetColumn="Denumire" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ESRPDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="ESRPDataSet" msprop:Generator_UserDSName="ESRPDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Adrese" msprop:Generator_TableClassName="AdreseDataTable" msprop:Generator_TableVarName="tableAdrese" msprop:Generator_RowChangedName="AdreseRowChanged" msprop:Generator_TablePropName="Adrese" msprop:Generator_RowDeletingName="AdreseRowDeleting" msprop:Generator_RowChangingName="AdreseRowChanging" msprop:Generator_RowEvHandlerName="AdreseRowChangeEventHandler" msprop:Generator_RowDeletedName="AdreseRowDeleted" msprop:Generator_RowClassName="AdreseRow" msprop:Generator_UserTableName="Adrese" msprop:Generator_RowEvArgName="AdreseRowChangeEvent">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDAdresa" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDAdresa" msprop:Generator_ColumnPropNameInRow="IDAdresa" msprop:Generator_ColumnPropNameInTable="IDAdresaColumn" msprop:Generator_UserColumnName="IDAdresa" type="xs:int" />
              <xs:element name="IDJudet" msprop:Generator_ColumnVarNameInTable="columnIDJudet" msprop:Generator_ColumnPropNameInRow="IDJudet" msprop:Generator_ColumnPropNameInTable="IDJudetColumn" msprop:Generator_UserColumnName="IDJudet" type="xs:int" minOccurs="0" />
              <xs:element name="IDLocalitati" msprop:Generator_ColumnVarNameInTable="columnIDLocalitati" msprop:Generator_ColumnPropNameInRow="IDLocalitati" msprop:Generator_ColumnPropNameInTable="IDLocalitatiColumn" msprop:Generator_UserColumnName="IDLocalitati" type="xs:int" minOccurs="0" />
              <xs:element name="Strada" msprop:Generator_ColumnVarNameInTable="columnStrada" msprop:Generator_ColumnPropNameInRow="Strada" msprop:Generator_ColumnPropNameInTable="StradaColumn" msprop:Generator_UserColumnName="Strada" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Numar" msprop:Generator_ColumnVarNameInTable="columnNumar" msprop:Generator_ColumnPropNameInRow="Numar" msprop:Generator_ColumnPropNameInTable="NumarColumn" msprop:Generator_UserColumnName="Numar" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Bloc" msprop:Generator_ColumnVarNameInTable="columnBloc" msprop:Generator_ColumnPropNameInRow="Bloc" msprop:Generator_ColumnPropNameInTable="BlocColumn" msprop:Generator_UserColumnName="Bloc" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Scara" msprop:Generator_ColumnVarNameInTable="columnScara" msprop:Generator_ColumnPropNameInRow="Scara" msprop:Generator_ColumnPropNameInTable="ScaraColumn" msprop:Generator_UserColumnName="Scara" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Apartament" msprop:Generator_ColumnVarNameInTable="columnApartament" msprop:Generator_ColumnPropNameInRow="Apartament" msprop:Generator_ColumnPropNameInTable="ApartamentColumn" msprop:Generator_UserColumnName="Apartament" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTara" msprop:Generator_ColumnVarNameInTable="columnIDTara" msprop:Generator_ColumnPropNameInRow="IDTara" msprop:Generator_ColumnPropNameInTable="IDTaraColumn" msprop:Generator_UserColumnName="IDTara" type="xs:int" minOccurs="0" />
              <xs:element name="Observatii" msprop:Generator_ColumnVarNameInTable="columnObservatii" msprop:Generator_ColumnPropNameInRow="Observatii" msprop:Generator_ColumnPropNameInTable="ObservatiiColumn" msprop:Generator_UserColumnName="Observatii" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDPartener" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" minOccurs="0" />
              <xs:element name="CodPostal" msprop:Generator_ColumnVarNameInTable="columnCodPostal" msprop:Generator_ColumnPropNameInRow="CodPostal" msprop:Generator_ColumnPropNameInTable="CodPostalColumn" msprop:Generator_UserColumnName="CodPostal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTipAdresa" msprop:Generator_ColumnVarNameInTable="columnIDTipAdresa" msprop:Generator_ColumnPropNameInRow="IDTipAdresa" msprop:Generator_ColumnPropNameInTable="IDTipAdresaColumn" msprop:Generator_UserColumnName="IDTipAdresa" type="xs:short" minOccurs="0" />
              <xs:element name="Telefon" msprop:Generator_ColumnVarNameInTable="columnTelefon" msprop:Generator_ColumnPropNameInRow="Telefon" msprop:Generator_ColumnPropNameInTable="TelefonColumn" msprop:Generator_UserColumnName="Telefon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnPropNameInTable="FaxColumn" msprop:Generator_UserColumnName="Fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Judete" msprop:Generator_TableClassName="JudeteDataTable" msprop:Generator_TableVarName="tableJudete" msprop:Generator_TablePropName="Judete" msprop:Generator_RowDeletingName="JudeteRowDeleting" msprop:Generator_RowChangingName="JudeteRowChanging" msprop:Generator_RowEvHandlerName="JudeteRowChangeEventHandler" msprop:Generator_RowDeletedName="JudeteRowDeleted" msprop:Generator_UserTableName="Judete" msprop:Generator_RowChangedName="JudeteRowChanged" msprop:Generator_RowEvArgName="JudeteRowChangeEvent" msprop:Generator_RowClassName="JudeteRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDJudet" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDJudet" msprop:Generator_ColumnPropNameInRow="IDJudet" msprop:Generator_ColumnPropNameInTable="IDJudetColumn" msprop:Generator_UserColumnName="IDJudet" type="xs:int" />
              <xs:element name="Nume" msprop:Generator_ColumnVarNameInTable="columnNume" msprop:Generator_ColumnPropNameInRow="Nume" msprop:Generator_ColumnPropNameInTable="NumeColumn" msprop:Generator_UserColumnName="Nume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Sigla" msprop:Generator_ColumnVarNameInTable="columnSigla" msprop:Generator_ColumnPropNameInRow="Sigla" msprop:Generator_ColumnPropNameInTable="SiglaColumn" msprop:Generator_UserColumnName="Sigla" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="PrefixTelefonic" msprop:Generator_ColumnVarNameInTable="columnPrefixTelefonic" msprop:Generator_ColumnPropNameInRow="PrefixTelefonic" msprop:Generator_ColumnPropNameInTable="PrefixTelefonicColumn" msprop:Generator_UserColumnName="PrefixTelefonic" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ResedintaJudet" msprop:Generator_ColumnVarNameInTable="columnResedintaJudet" msprop:Generator_ColumnPropNameInRow="ResedintaJudet" msprop:Generator_ColumnPropNameInTable="ResedintaJudetColumn" msprop:Generator_UserColumnName="ResedintaJudet" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Localitati" msprop:Generator_TableClassName="LocalitatiDataTable" msprop:Generator_TableVarName="tableLocalitati" msprop:Generator_TablePropName="Localitati" msprop:Generator_RowDeletingName="LocalitatiRowDeleting" msprop:Generator_RowChangingName="LocalitatiRowChanging" msprop:Generator_RowEvHandlerName="LocalitatiRowChangeEventHandler" msprop:Generator_RowDeletedName="LocalitatiRowDeleted" msprop:Generator_UserTableName="Localitati" msprop:Generator_RowChangedName="LocalitatiRowChanged" msprop:Generator_RowEvArgName="LocalitatiRowChangeEvent" msprop:Generator_RowClassName="LocalitatiRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDLocalitate" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDLocalitate" msprop:Generator_ColumnPropNameInRow="IDLocalitate" msprop:Generator_ColumnPropNameInTable="IDLocalitateColumn" msprop:Generator_UserColumnName="IDLocalitate" type="xs:int" />
              <xs:element name="Nume" msprop:Generator_ColumnVarNameInTable="columnNume" msprop:Generator_ColumnPropNameInRow="Nume" msprop:Generator_ColumnPropNameInTable="NumeColumn" msprop:Generator_UserColumnName="Nume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="CodPostal" msprop:Generator_ColumnVarNameInTable="columnCodPostal" msprop:Generator_ColumnPropNameInRow="CodPostal" msprop:Generator_ColumnPropNameInTable="CodPostalColumn" msprop:Generator_UserColumnName="CodPostal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="6" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDJudet" msprop:Generator_ColumnVarNameInTable="columnIDJudet" msprop:Generator_ColumnPropNameInRow="IDJudet" msprop:Generator_ColumnPropNameInTable="IDJudetColumn" msprop:Generator_UserColumnName="IDJudet" type="xs:int" minOccurs="0" />
              <xs:element name="PrefixTelefonic" msprop:Generator_ColumnVarNameInTable="columnPrefixTelefonic" msprop:Generator_ColumnPropNameInRow="PrefixTelefonic" msprop:Generator_ColumnPropNameInTable="PrefixTelefonicColumn" msprop:Generator_UserColumnName="PrefixTelefonic" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Tari" msprop:Generator_TableClassName="TariDataTable" msprop:Generator_TableVarName="tableTari" msprop:Generator_TablePropName="Tari" msprop:Generator_RowDeletingName="TariRowDeleting" msprop:Generator_RowChangingName="TariRowChanging" msprop:Generator_RowEvHandlerName="TariRowChangeEventHandler" msprop:Generator_RowDeletedName="TariRowDeleted" msprop:Generator_UserTableName="Tari" msprop:Generator_RowChangedName="TariRowChanged" msprop:Generator_RowEvArgName="TariRowChangeEvent" msprop:Generator_RowClassName="TariRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTara" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDTara" msprop:Generator_ColumnPropNameInRow="IDTara" msprop:Generator_ColumnPropNameInTable="IDTaraColumn" msprop:Generator_UserColumnName="IDTara" type="xs:int" />
              <xs:element name="NUME" msprop:Generator_ColumnVarNameInTable="columnNUME" msprop:Generator_ColumnPropNameInRow="NUME" msprop:Generator_ColumnPropNameInTable="NUMEColumn" msprop:Generator_UserColumnName="NUME" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SIGLA" msprop:Generator_ColumnVarNameInTable="columnSIGLA" msprop:Generator_ColumnPropNameInRow="SIGLA" msprop:Generator_ColumnPropNameInTable="SIGLAColumn" msprop:Generator_UserColumnName="SIGLA" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="preftel" msprop:Generator_ColumnVarNameInTable="columnpreftel" msprop:Generator_ColumnPropNameInRow="preftel" msprop:Generator_ColumnPropNameInTable="preftelColumn" msprop:Generator_UserColumnName="preftel" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TipAdresa" msprop:Generator_TableClassName="TipAdresaDataTable" msprop:Generator_TableVarName="tableTipAdresa" msprop:Generator_TablePropName="TipAdresa" msprop:Generator_RowDeletingName="TipAdresaRowDeleting" msprop:Generator_RowChangingName="TipAdresaRowChanging" msprop:Generator_RowEvHandlerName="TipAdresaRowChangeEventHandler" msprop:Generator_RowDeletedName="TipAdresaRowDeleted" msprop:Generator_UserTableName="TipAdresa" msprop:Generator_RowChangedName="TipAdresaRowChanged" msprop:Generator_RowEvArgName="TipAdresaRowChangeEvent" msprop:Generator_RowClassName="TipAdresaRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTipAdresa" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDTipAdresa" msprop:Generator_ColumnPropNameInRow="IDTipAdresa" msprop:Generator_ColumnPropNameInTable="IDTipAdresaColumn" msprop:Generator_UserColumnName="IDTipAdresa" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Contact" msprop:Generator_TableClassName="ContactDataTable" msprop:Generator_TableVarName="tableContact" msprop:Generator_TablePropName="Contact" msprop:Generator_RowDeletingName="ContactRowDeleting" msprop:Generator_RowChangingName="ContactRowChanging" msprop:Generator_RowEvHandlerName="ContactRowChangeEventHandler" msprop:Generator_RowDeletedName="ContactRowDeleted" msprop:Generator_UserTableName="Contact" msprop:Generator_RowChangedName="ContactRowChanged" msprop:Generator_RowEvArgName="ContactRowChangeEvent" msprop:Generator_RowClassName="ContactRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDContact" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDContact" msprop:Generator_ColumnPropNameInRow="IDContact" msprop:Generator_ColumnPropNameInTable="IDContactColumn" msprop:Generator_UserColumnName="IDContact" type="xs:int" />
              <xs:element name="Nume" msprop:Generator_ColumnVarNameInTable="columnNume" msprop:Generator_ColumnPropNameInRow="Nume" msprop:Generator_ColumnPropNameInTable="NumeColumn" msprop:Generator_UserColumnName="Nume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Prenume" msprop:Generator_ColumnVarNameInTable="columnPrenume" msprop:Generator_ColumnPropNameInRow="Prenume" msprop:Generator_ColumnPropNameInTable="PrenumeColumn" msprop:Generator_UserColumnName="Prenume" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDTipContact" msprop:Generator_ColumnVarNameInTable="columnIDTipContact" msprop:Generator_ColumnPropNameInRow="IDTipContact" msprop:Generator_ColumnPropNameInTable="IDTipContactColumn" msprop:Generator_UserColumnName="IDTipContact" type="xs:short" minOccurs="0" />
              <xs:element name="CNP" msprop:Generator_ColumnVarNameInTable="columnCNP" msprop:Generator_ColumnPropNameInRow="CNP" msprop:Generator_ColumnPropNameInTable="CNPColumn" msprop:Generator_UserColumnName="CNP" type="xs:decimal" minOccurs="0" />
              <xs:element name="StareCivila" msprop:Generator_ColumnVarNameInTable="columnStareCivila" msprop:Generator_ColumnPropNameInRow="StareCivila" msprop:Generator_ColumnPropNameInTable="StareCivilaColumn" msprop:Generator_UserColumnName="StareCivila" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Functie" msprop:Generator_ColumnVarNameInTable="columnFunctie" msprop:Generator_ColumnPropNameInRow="Functie" msprop:Generator_ColumnPropNameInTable="FunctieColumn" msprop:Generator_UserColumnName="Functie" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Departament" msprop:Generator_ColumnVarNameInTable="columnDepartament" msprop:Generator_ColumnPropNameInRow="Departament" msprop:Generator_ColumnPropNameInTable="DepartamentColumn" msprop:Generator_UserColumnName="Departament" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TipAI" msprop:Generator_ColumnVarNameInTable="columnTipAI" msprop:Generator_ColumnPropNameInRow="TipAI" msprop:Generator_ColumnPropNameInTable="TipAIColumn" msprop:Generator_UserColumnName="TipAI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SerieAI" msprop:Generator_ColumnVarNameInTable="columnSerieAI" msprop:Generator_ColumnPropNameInRow="SerieAI" msprop:Generator_ColumnPropNameInTable="SerieAIColumn" msprop:Generator_UserColumnName="SerieAI" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="NumarAI" msprop:Generator_ColumnVarNameInTable="columnNumarAI" msprop:Generator_ColumnPropNameInRow="NumarAI" msprop:Generator_ColumnPropNameInTable="NumarAIColumn" msprop:Generator_UserColumnName="NumarAI" type="xs:decimal" minOccurs="0" />
              <xs:element name="IDPartener" msprop:Generator_ColumnVarNameInTable="columnIDPartener" msprop:Generator_ColumnPropNameInRow="IDPartener" msprop:Generator_ColumnPropNameInTable="IDPartenerColumn" msprop:Generator_UserColumnName="IDPartener" type="xs:long" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="InfoContact" msprop:Generator_TableClassName="InfoContactDataTable" msprop:Generator_TableVarName="tableInfoContact" msprop:Generator_TablePropName="InfoContact" msprop:Generator_RowDeletingName="InfoContactRowDeleting" msprop:Generator_RowChangingName="InfoContactRowChanging" msprop:Generator_RowEvHandlerName="InfoContactRowChangeEventHandler" msprop:Generator_RowDeletedName="InfoContactRowDeleted" msprop:Generator_UserTableName="InfoContact" msprop:Generator_RowChangedName="InfoContactRowChanged" msprop:Generator_RowEvArgName="InfoContactRowChangeEvent" msprop:Generator_RowClassName="InfoContactRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDInfoContact" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDInfoContact" msprop:Generator_ColumnPropNameInRow="IDInfoContact" msprop:Generator_ColumnPropNameInTable="IDInfoContactColumn" msprop:Generator_UserColumnName="IDInfoContact" type="xs:int" />
              <xs:element name="Telefon" msprop:Generator_ColumnVarNameInTable="columnTelefon" msprop:Generator_ColumnPropNameInRow="Telefon" msprop:Generator_ColumnPropNameInTable="TelefonColumn" msprop:Generator_UserColumnName="Telefon" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mobil" msprop:Generator_ColumnVarNameInTable="columnMobil" msprop:Generator_ColumnPropNameInRow="Mobil" msprop:Generator_ColumnPropNameInTable="MobilColumn" msprop:Generator_UserColumnName="Mobil" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TelefonPersonal" msprop:Generator_ColumnVarNameInTable="columnTelefonPersonal" msprop:Generator_ColumnPropNameInRow="TelefonPersonal" msprop:Generator_ColumnPropNameInTable="TelefonPersonalColumn" msprop:Generator_UserColumnName="TelefonPersonal" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Fax" msprop:Generator_ColumnVarNameInTable="columnFax" msprop:Generator_ColumnPropNameInRow="Fax" msprop:Generator_ColumnPropNameInTable="FaxColumn" msprop:Generator_UserColumnName="Fax" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Email" msprop:Generator_ColumnVarNameInTable="columnEmail" msprop:Generator_ColumnPropNameInRow="Email" msprop:Generator_ColumnPropNameInTable="EmailColumn" msprop:Generator_UserColumnName="Email" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="YMID" msprop:Generator_ColumnVarNameInTable="columnYMID" msprop:Generator_ColumnPropNameInRow="YMID" msprop:Generator_ColumnPropNameInTable="YMIDColumn" msprop:Generator_UserColumnName="YMID" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WebSite" msprop:Generator_ColumnVarNameInTable="columnWebSite" msprop:Generator_ColumnPropNameInRow="WebSite" msprop:Generator_ColumnPropNameInTable="WebSiteColumn" msprop:Generator_UserColumnName="WebSite" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="150" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IDContact" msprop:Generator_ColumnVarNameInTable="columnIDContact" msprop:Generator_ColumnPropNameInRow="IDContact" msprop:Generator_ColumnPropNameInTable="IDContactColumn" msprop:Generator_UserColumnName="IDContact" type="xs:int" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TipContact" msprop:Generator_TableClassName="TipContactDataTable" msprop:Generator_TableVarName="tableTipContact" msprop:Generator_TablePropName="TipContact" msprop:Generator_RowDeletingName="TipContactRowDeleting" msprop:Generator_RowChangingName="TipContactRowChanging" msprop:Generator_RowEvHandlerName="TipContactRowChangeEventHandler" msprop:Generator_RowDeletedName="TipContactRowDeleted" msprop:Generator_UserTableName="TipContact" msprop:Generator_RowChangedName="TipContactRowChanged" msprop:Generator_RowEvArgName="TipContactRowChangeEvent" msprop:Generator_RowClassName="TipContactRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IDTipContact" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnIDTipContact" msprop:Generator_ColumnPropNameInRow="IDTipContact" msprop:Generator_ColumnPropNameInTable="IDTipContactColumn" msprop:Generator_UserColumnName="IDTipContact" type="xs:short" />
              <xs:element name="Denumire" msprop:Generator_ColumnVarNameInTable="columnDenumire" msprop:Generator_ColumnPropNameInRow="Denumire" msprop:Generator_ColumnPropNameInTable="DenumireColumn" msprop:Generator_UserColumnName="Denumire">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Adrese" />
      <xs:field xpath="mstns:IDAdresa" />
    </xs:unique>
    <xs:unique name="Judete_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Judete" />
      <xs:field xpath="mstns:IDJudet" />
    </xs:unique>
    <xs:unique name="Localitati_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Localitati" />
      <xs:field xpath="mstns:IDLocalitate" />
    </xs:unique>
    <xs:unique name="Tari_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Tari" />
      <xs:field xpath="mstns:IDTara" />
    </xs:unique>
    <xs:unique name="TipAdresa_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TipAdresa" />
      <xs:field xpath="mstns:IDTipAdresa" />
    </xs:unique>
    <xs:unique name="Contact_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Contact" />
      <xs:field xpath="mstns:IDContact" />
    </xs:unique>
    <xs:unique name="InfoContact_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:InfoContact" />
      <xs:field xpath="mstns:IDInfoContact" />
    </xs:unique>
    <xs:unique name="TipContact_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TipContact" />
      <xs:field xpath="mstns:IDTipContact" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_Adrese_Judete" msdata:parent="Judete" msdata:child="Adrese" msdata:parentkey="IDJudet" msdata:childkey="IDJudet" msprop:Generator_UserChildTable="Adrese" msprop:Generator_ChildPropName="GetAdreseRows" msprop:Generator_UserRelationName="FK_Adrese_Judete" msprop:Generator_RelationVarName="relationFK_Adrese_Judete" msprop:Generator_UserParentTable="Judete" msprop:Generator_ParentPropName="JudeteRow" />
      <msdata:Relationship name="FK_Adrese_Localitati" msdata:parent="Localitati" msdata:child="Adrese" msdata:parentkey="IDLocalitate" msdata:childkey="IDLocalitati" msprop:Generator_UserChildTable="Adrese" msprop:Generator_ChildPropName="GetAdreseRows" msprop:Generator_UserRelationName="FK_Adrese_Localitati" msprop:Generator_RelationVarName="relationFK_Adrese_Localitati" msprop:Generator_UserParentTable="Localitati" msprop:Generator_ParentPropName="LocalitatiRow" />
      <msdata:Relationship name="FK_Adrese_Tari" msdata:parent="Tari" msdata:child="Adrese" msdata:parentkey="IDTara" msdata:childkey="IDTara" msprop:Generator_UserChildTable="Adrese" msprop:Generator_ChildPropName="GetAdreseRows" msprop:Generator_UserRelationName="FK_Adrese_Tari" msprop:Generator_RelationVarName="relationFK_Adrese_Tari" msprop:Generator_UserParentTable="Tari" msprop:Generator_ParentPropName="TariRow" />
      <msdata:Relationship name="FK_LOCALITATI_JUDETE" msdata:parent="Judete" msdata:child="Localitati" msdata:parentkey="IDJudet" msdata:childkey="IDJudet" msprop:Generator_UserChildTable="Localitati" msprop:Generator_ChildPropName="GetLocalitatiRows" msprop:Generator_UserRelationName="FK_LOCALITATI_JUDETE" msprop:Generator_ParentPropName="JudeteRow" msprop:Generator_RelationVarName="relationFK_LOCALITATI_JUDETE" msprop:Generator_UserParentTable="Judete" />
      <msdata:Relationship name="FK_Contact_TipContact" msdata:parent="TipContact" msdata:child="Contact" msdata:parentkey="IDTipContact" msdata:childkey="IDTipContact" msprop:Generator_UserChildTable="Contact" msprop:Generator_ChildPropName="GetContactRows" msprop:Generator_UserRelationName="FK_Contact_TipContact" msprop:Generator_RelationVarName="relationFK_Contact_TipContact" msprop:Generator_UserParentTable="TipContact" msprop:Generator_ParentPropName="TipContactRow" />
      <msdata:Relationship name="FK_InfoContact_Contact" msdata:parent="Contact" msdata:child="InfoContact" msdata:parentkey="IDContact" msdata:childkey="IDContact" msprop:Generator_UserChildTable="InfoContact" msprop:Generator_ChildPropName="GetInfoContactRows" msprop:Generator_UserRelationName="FK_InfoContact_Contact" msprop:Generator_ParentPropName="ContactRow" msprop:Generator_RelationVarName="relationFK_InfoContact_Contact" msprop:Generator_UserParentTable="Contact" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>